Desktop Computer Skills
Microsoft Office 2010: Power User Excel
Manipulating Formulas and Using Forms in Excel 2010
mo_pexl_a04_dt_enus
Sharing Excel 2010 Workbooks Online and on a Network
mo_pexl_a01_dt_enus
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
mo_pexl_a05_dt_enus
Using Excel 2010 to Collaborate Online and with Other Office Applications
mo_pexl_a02_dt_enus
Using Lookup, Reference, Math, and Text Functions in Excel 2010
mo_pexl_a03_dt_enus
Manipulating Formulas and Using Forms in Excel 2010
Lesson Objectives
Manipulating Formulas and Using Forms in Excel 2010
- use statistical functions in Excel 2010
- recognize when to use cube functions
- use conditional functions in Excel 2010
- recognize when to use conditional functions
- use array formulas in Excel 2010
- use advanced Excel functions
- add and edit ActiveX Controls in an Excel worksheet
Overview/Description
Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course explores the available cube functions, such as CUBEMEMBER, CUBESET, and CUBEVALUE. Summarizing data using conditional functions such as SUMIF and COUNTIFS are also covered. This course also examines the methods Excel 2010 provides for working with arrays, including one-dimensional and two-dimensional arrays. Adding form and ActiveX Controls to Excel worksheets is also covered.
Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course explores the available cube functions, such as CUBEMEMBER, CUBESET, and CUBEVALUE. Summarizing data using conditional functions such as SUMIF and COUNTIFS are also covered. This course also examines the methods Excel 2010 provides for working with arrays, including one-dimensional and two-dimensional arrays. Adding form and ActiveX Controls to Excel worksheets is also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Prerequisites: none
Manipulating Formulas and Using Forms in Excel 2010
Lesson Objectives
Manipulating Formulas and Using Forms in Excel 2010
- use statistical functions in Excel 2010
- recognize when to use cube functions
- use conditional functions in Excel 2010
- recognize when to use conditional functions
- use array formulas in Excel 2010
- use advanced Excel functions
- add and edit ActiveX Controls in an Excel worksheet
Overview/Description
Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course explores the available cube functions, such as CUBEMEMBER, CUBESET, and CUBEVALUE. Summarizing data using conditional functions such as SUMIF and COUNTIFS are also covered. This course also examines the methods Excel 2010 provides for working with arrays, including one-dimensional and two-dimensional arrays. Adding form and ActiveX Controls to Excel worksheets is also covered.
Excel 2010 provides a large variety of statistical functions that allow you to perform data analysis on worksheet data, several cube functions that allow you to return information from cubes, and the means of working with arrays. In addition, using the Developer tab, you can further customize an Excel workbook to increase its functionality with form and ActiveX Controls. This courses discusses various statistical functions, include those designed to work with averages, determine the median, pinpoint rank and percentages, and sample populations. In addition, this course explores the available cube functions, such as CUBEMEMBER, CUBESET, and CUBEVALUE. Summarizing data using conditional functions such as SUMIF and COUNTIFS are also covered. This course also examines the methods Excel 2010 provides for working with arrays, including one-dimensional and two-dimensional arrays. Adding form and ActiveX Controls to Excel worksheets is also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Prerequisites: none
Sharing Excel 2010 Workbooks Online and on a Network
Lesson Objectives
Sharing Excel 2010 Workbooks Online and on a Network
- share a workbook with advanced sharing settings
- recognize features that are available in a shared workbook
- protect a workbook with Information Rights Management (IRM)
- allow users to edit specific ranges in a protected worksheet
- save a workbook as a Web file
- share Excel 2010 workbooks
Overview/Description
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in a shared workbook. This course covers sharing Excel 2010 workbooks on a network with advanced sharing options, the limitations of shared workbooks, and the uses and limitations of IRM. It also covers how to limit users' editing to specific cell ranges in a worksheet, and how to apply the AutoRepublish feature when saving workbooks for use on the Web.
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in a shared workbook. This course covers sharing Excel 2010 workbooks on a network with advanced sharing options, the limitations of shared workbooks, and the uses and limitations of IRM. It also covers how to limit users' editing to specific cell ranges in a worksheet, and how to apply the AutoRepublish feature when saving workbooks for use on the Web.
Target Audience
End users who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments
End users who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments
Prerequisites: none
Sharing Excel 2010 Workbooks Online and on a Network
Lesson Objectives
Sharing Excel 2010 Workbooks Online and on a Network
- share a workbook with advanced sharing settings
- recognize features that are available in a shared workbook
- protect a workbook with Information Rights Management (IRM)
- allow users to edit specific ranges in a protected worksheet
- save a workbook as a Web file
- share Excel 2010 workbooks
Overview/Description
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in a shared workbook. This course covers sharing Excel 2010 workbooks on a network with advanced sharing options, the limitations of shared workbooks, and the uses and limitations of IRM. It also covers how to limit users' editing to specific cell ranges in a worksheet, and how to apply the AutoRepublish feature when saving workbooks for use on the Web.
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in a shared workbook. This course covers sharing Excel 2010 workbooks on a network with advanced sharing options, the limitations of shared workbooks, and the uses and limitations of IRM. It also covers how to limit users' editing to specific cell ranges in a worksheet, and how to apply the AutoRepublish feature when saving workbooks for use on the Web.
Target Audience
End users who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments
End users who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments
Prerequisites: none
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
Lesson Objectives
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
- use and configure existing data connections
- create a web query
- recognize when to use a web query
- create a data connection to an XML file
- create a data connection to a data source using the Query Wizard
- use data connections in Excel 2010
Overview/Description
There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online data and use it within Excel. Importing XML data is covered, and the course also describes the process of using the Query Wizard to create and edit queries.
There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online data and use it within Excel. Importing XML data is covered, and the course also describes the process of using the Query Wizard to create and edit queries.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Prerequisites: none
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
Lesson Objectives
Using Excel 2010 Data Connections: Web Queries, XML, and Databases
- use and configure existing data connections
- create a web query
- recognize when to use a web query
- create a data connection to an XML file
- create a data connection to a data source using the Query Wizard
- use data connections in Excel 2010
Overview/Description
There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online data and use it within Excel. Importing XML data is covered, and the course also describes the process of using the Query Wizard to create and edit queries.
There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online data and use it within Excel. Importing XML data is covered, and the course also describes the process of using the Query Wizard to create and edit queries.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Prerequisites: none
Using Excel 2010 to Collaborate Online and with Other Office Applications
Lesson Objectives
Using Excel 2010 to Collaborate Online and with Other Office Applications
- identify scenarios appropriate for using Excel Web App
- export data from Excel to SharePoint
- export data from SharePoint to Excel
- paste the contents of another Office file into an Excel worksheet
- add an Office document to an Excel worksheet
- manage linked Office files in Excel
- use Excel 2010 with other applications
Overview/Description
Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in today's business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including information on the Web App interface, its limitations, and how to access the full version of Excel 2010 from within it. In addition, this course covers exporting data from a SharePoint list to Excel, and exporting data from Excel into a SharePoint list. Linking Office 2010 content to and embedding Office 2010 content in Excel workbooks is also covered.
Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in today's business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including information on the Web App interface, its limitations, and how to access the full version of Excel 2010 from within it. In addition, this course covers exporting data from a SharePoint list to Excel, and exporting data from Excel into a SharePoint list. Linking Office 2010 content to and embedding Office 2010 content in Excel workbooks is also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Prerequisites: none
Using Excel 2010 to Collaborate Online and with Other Office Applications
Lesson Objectives
Using Excel 2010 to Collaborate Online and with Other Office Applications
- identify scenarios appropriate for using Excel Web App
- export data from Excel to SharePoint
- export data from SharePoint to Excel
- paste the contents of another Office file into an Excel worksheet
- add an Office document to an Excel worksheet
- manage linked Office files in Excel
- use Excel 2010 with other applications
Overview/Description
Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in today's business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including information on the Web App interface, its limitations, and how to access the full version of Excel 2010 from within it. In addition, this course covers exporting data from a SharePoint list to Excel, and exporting data from Excel into a SharePoint list. Linking Office 2010 content to and embedding Office 2010 content in Excel workbooks is also covered.
Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in today's business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including information on the Web App interface, its limitations, and how to access the full version of Excel 2010 from within it. In addition, this course covers exporting data from a SharePoint list to Excel, and exporting data from Excel into a SharePoint list. Linking Office 2010 content to and embedding Office 2010 content in Excel workbooks is also covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Prerequisites: none
Using Lookup, Reference, Math, and Text Functions in Excel 2010
Lesson Objectives
Using Lookup, Reference, Math, and Text Functions in Excel 2010
- use lookup functions in Excel 2010
- recognize when to use the lookup functions in Excel 2010
- use reference functions in Excel 2010
- use math functions in Excel 2010
- recognize when to use the rounding functions in Excel 2010
- use trig functions in Excel 2010
- use text functions in Excel 2010
- use advanced functions in Excel 2010
Overview/Description
The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered.
The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Prerequisites: none
Using Lookup, Reference, Math, and Text Functions in Excel 2010
Lesson Objectives
Using Lookup, Reference, Math, and Text Functions in Excel 2010
- use lookup functions in Excel 2010
- recognize when to use the lookup functions in Excel 2010
- use reference functions in Excel 2010
- use math functions in Excel 2010
- recognize when to use the rounding functions in Excel 2010
- use trig functions in Excel 2010
- use text functions in Excel 2010
- use advanced functions in Excel 2010
Overview/Description
The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered.
The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered.
Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments
Prerequisites: none
